Release 10.1A: OpenEdge Development:
Programming Interfaces
Sample record fetches
The following examples show some of the many ways you can access records. These examples are not meant to be exhaustive, but merely to show some of the flexibility provided by Progress.
- Specify the
FIRST,LAST,NEXT, orPREVoptions to step through all records in a particular sequence:
- Specify boolean expressions to describe the record or records to be fetched:
- Specify a constant value of the primary index for the record. This works only if the primary index is single-component. Also, this technique is not supported for the
OPENQUERYstatement:
- Specify one or more field values that are currently in the screen buffer or record buffer:
- Specify a previously found related record from another table (the two tables must share a field with the same name, and that field must have a
UNIQUEindex in at least one of the tables):
- Specify a
CONTAINSclause on a word-indexed field:
You cannot use a
CONTAINSclause with theFINDstatement. You can useCONTAINSonly with theOPENQUERYandFOREACHstatements.
|
Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |